<?php
header('Location:list_sz.php');
exit;
/*
header("Content-Type: text/html; charset=utf-8");
//require_once '../setting/setting.php';
//require_once '../lib/query_railway.php';
//require_once '../lib/base.php';


$sql="Drop table if exists $tb_start;";
$query=$db->query($sql);
$sql="CREATE TABLE `$tb_start` (              
           `cn` varchar(100) DEFAULT NULL,                      
           `en` varchar(100) DEFAULT NULL,                      
           `pv` varchar(100) DEFAULT NULL,                      
           `id` int(11) NOT NULL AUTO_INCREMENT,                
           PRIMARY KEY (`id`)                                   
         ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8";
$query=$db->query($sql);
$data=get_array("start_station");
QR::add_data($tb_start,$data);

$sql="Drop table if exists $tb_border;";
$query=$db->query($sql);
$sql="CREATE TABLE `$tb_border` (              
           `cn` varchar(100) DEFAULT NULL,                      
           `id` int(11) NOT NULL AUTO_INCREMENT,                
           PRIMARY KEY (`id`)                                   
         ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8";
$query=$db->query($sql);
$data=get_array("tran_station");
QR::add_data($tb_border,$data);

$sql="Drop table if exists $tb_end;";
$query=$db->query($sql);
$sql="CREATE TABLE `$tb_end` (              
           `code` varchar(100) DEFAULT NULL,                    
           `en` varchar(100) DEFAULT NULL,                      
           `cn` varchar(100) DEFAULT NULL,                      
           `ru` varchar(100) DEFAULT NULL,                      
           `cy` varchar(100) DEFAULT NULL,                      
           `id` int(11) NOT NULL AUTO_INCREMENT,                
           PRIMARY KEY (`id`)                                   
         ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8";
$query=$db->query($sql);
$data=get_array("end_station");
QR::add_data($tb_end,$data);

$sql="Drop table if exists $tb_box;";
$query=$db->query($sql);
$sql="CREATE TABLE `$tb_box` (            
             `type` varchar(100) DEFAULT NULL    
           ) ENGINE=MyISAM DEFAULT CHARSET=utf8";
$query=$db->query($sql);
$data=get_array("box_type");
QR::add_data($tb_box,$data);

$sql="Drop table if exists $tb_start_border;";
$query=$db->query($sql);
$sql="CREATE TABLE `$tb_start_border` (                               
            `id` int(11) NOT NULL AUTO_INCREMENT,                 
            `start` varchar(100) DEFAULT NULL,                     
            `border` varchar(100) DEFAULT NULL,                    
            `end` varchar(100) DEFAULT NULL,                       
            `p20` float DEFAULT NULL,                             
            `p40gp` float DEFAULT NULL,                           
            `p40hc` float DEFAULT NULL,                           
            `box` varchar(100) DEFAULT NULL,                      
            `ctime` datetime DEFAULT NULL,                        
            `stime` datetime DEFAULT NULL,                        
            `remark` text,                   
            PRIMARY KEY (`id`)                                    
          ) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ";
$query=$db->query($sql);

$sql="Drop table if exists $tb_border_end;";
$query=$db->query($sql);
$sql="CREATE TABLE `$tb_border_end` (                               
            `id` int(11) NOT NULL AUTO_INCREMENT,                 
            `start` varchar(100) DEFAULT NULL,                     
            `border` varchar(100) DEFAULT NULL,                    
            `end` varchar(100) DEFAULT NULL,                       
            `p20` float DEFAULT NULL,                             
            `p40gp` float DEFAULT NULL,                           
            `p40hc` float DEFAULT NULL,                           
            `box` varchar(100) DEFAULT NULL,                      
            `ctime` datetime DEFAULT NULL,                        
            `stime` datetime DEFAULT NULL,                        
            `remark` text,                 
            PRIMARY KEY (`id`)                                    
          ) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 ";
$query=$db->query($sql);

*/
?>